Overview

Dataset statistics

Number of variables26
Number of observations292
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory72.0 KiB
Average record size in memory252.4 B

Variable types

NUM16
BOOL8
CAT1
DATE1

Reproduction

Analysis started2020-05-05 17:44:48.952647
Analysis finished2020-05-05 17:45:25.847126
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
udsventa has 57 (19.5%) zeros Zeros
udsprevisionempresa has 81 (27.7%) zeros Zeros
weekday has 41 (14.0%) zeros Zeros
sin_weekday has 41 (14.0%) zeros Zeros
roll4wd_udsventa has 50 (17.1%) zeros Zeros
roll4wd_udsstock has 18 (6.2%) zeros Zeros
udsprevisionempresa_shifted-1 has 82 (28.1%) zeros Zeros
udsprevisionempresa_shifted-2 has 83 (28.4%) zeros Zeros
udsstock_shifted7 has 7 (2.4%) zeros Zeros
roll4wd_udsstock_shifted1 has 19 (6.5%) zeros Zeros
roll4wd_udsstock_shifted7 has 25 (8.6%) zeros Zeros
udsventa_shifted1 has 57 (19.5%) zeros Zeros

Variables

fecha
Date

UNIFORM
UNIQUE
Distinct count292
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
Minimum2019-06-05 00:00:00
Maximum2020-03-22 00:00:00
Histogram

producto
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
30
292
ValueCountFrequency (%) 
30 292 100.0%
 

Length

Max length2
Mean length2
Min length2
ValueCountFrequency (%) 
Decimal_Number 2 100.0%
 
ValueCountFrequency (%) 
Common 2 100.0%
 
ValueCountFrequency (%) 
ASCII 2 100.0%
 

udsstock
Real number (ℝ≥0)

Distinct count112
Unique (%)38.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1123.1678761497085
Minimum39.0
Maximum2275.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum39
5-th percentile563.4
Q1874.75
median1059
Q31378.633333
95-th percentile1762.85
Maximum2275
Range2236
Interquartile range (IQR)503.8833333

Descriptive statistics

Standard deviation369.2913773
Coefficient of variation (CV)0.3287944618
Kurtosis0.5477746242
Mean1123.167876
Median Absolute Deviation (MAD)294.8023626
Skewness0.06362069422
Sum327965.0198
Variance136376.1214
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 39. 600.5 801.22580645 807.72580645 983.96 ... 1065.5 1296.94827586 1303.44827586 1547.5 2275. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
985.92 28 9.6%
 
1432.423077 15 5.1%
 
801.4516129 13 4.5%
 
1378.633333 12 4.1%
 
1301.896552 11 3.8%
 
1055.258065 10 3.4%
 
1046 7 2.4%
 
982 6 2.1%
 
1201 6 2.1%
 
762 6 2.1%
 
Other values (102) 178 61.0%
 
ValueCountFrequency (%) 
39 1 0.3%
 
64 1 0.3%
 
129 1 0.3%
 
211 1 0.3%
 
232 1 0.3%
 
ValueCountFrequency (%) 
2275 1 0.3%
 
2261 1 0.3%
 
2157 1 0.3%
 
1989 1 0.3%
 
1951 1 0.3%
 

udsventa
Real number (ℝ≥0)

ZEROS
Distinct count81
Unique (%)27.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean471.44520547945206
Minimum0.0
Maximum1938.0
Zeros57
Zeros (%)19.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1282.5
median492
Q3651.5
95-th percentile923.55
Maximum1938
Range1938
Interquartile range (IQR)369

Descriptive statistics

Standard deviation325.9941713
Coefficient of variation (CV)0.6914783893
Kurtosis1.916153376
Mean471.4452055
Median Absolute Deviation (MAD)246.4124132
Skewness0.6407138395
Sum137662
Variance106272.1997
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 68.5 231. 713. 959. 1938. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 57 19.5%
 
511 9 3.1%
 
600 7 2.4%
 
492 7 2.4%
 
590 7 2.4%
 
442 6 2.1%
 
314 6 2.1%
 
649 6 2.1%
 
354 6 2.1%
 
432 6 2.1%
 
Other values (71) 175 59.9%
 
ValueCountFrequency (%) 
0 57 19.5%
 
137 1 0.3%
 
147 1 0.3%
 
157 1 0.3%
 
216 1 0.3%
 
ValueCountFrequency (%) 
1938 1 0.3%
 
1741 1 0.3%
 
1603 2 0.7%
 
1407 1 0.3%
 
1170 1 0.3%
 

udsprevisionempresa
Real number (ℝ≥0)

ZEROS
Distinct count199
Unique (%)68.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2104.6335616438355
Minimum0.0
Maximum17426.0
Zeros81
Zeros (%)27.7%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1504
Q33248
95-th percentile6710.75
Maximum17426
Range17426
Interquartile range (IQR)3248

Descriptive statistics

Standard deviation2438.826205
Coefficient of variation (CV)1.158788993
Kurtosis7.381238809
Mean2104.633562
Median Absolute Deviation (MAD)1786.92447
Skewness2.130107474
Sum614553
Variance5947873.257
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 31. 3955.5 7280.5 17426. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 81 27.7%
 
2078 2 0.7%
 
1050 2 0.7%
 
1700 2 0.7%
 
1889 2 0.7%
 
2987 2 0.7%
 
123 2 0.7%
 
1613 2 0.7%
 
2084 2 0.7%
 
712 2 0.7%
 
Other values (189) 193 66.1%
 
ValueCountFrequency (%) 
0 81 27.7%
 
62 1 0.3%
 
98 1 0.3%
 
123 2 0.7%
 
169 1 0.3%
 
ValueCountFrequency (%) 
17426 1 0.3%
 
13665 1 0.3%
 
11310 1 0.3%
 
10044 1 0.3%
 
10028 1 0.3%
 

promo
Boolean

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
292
ValueCountFrequency (%) 
0 292 100.0%
 

festivo
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
284
1
 
8
ValueCountFrequency (%) 
0 284 97.3%
 
1 8 2.7%
 

weekday
Real number (ℝ≥0)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.017123287671233
Minimum0
Maximum6
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median3
Q35
95-th percentile6
Maximum6
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.999067122
Coefficient of variation (CV)0.662573893
Kurtosis-1.24431598
Mean3.017123288
Median Absolute Deviation (MAD)1.711249765
Skewness-0.01071552041
Sum881
Variance3.996269359
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 5.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 
1 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
0 41 14.0%
 
1 41 14.0%
 
2 42 14.4%
 
3 42 14.4%
 
4 42 14.4%
 
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 
Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
True
242
False
50
ValueCountFrequency (%) 
True 242 82.9%
 
False 50 17.1%
 

sin_weekday
Real number (ℝ)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.002677505076945293
Minimum-0.9749279121818236
Maximum0.9749279121818236
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9749279122
5-th percentile-0.9749279122
Q1-0.7818314825
median0
Q30.7818314825
95-th percentile0.9749279122
Maximum0.9749279122
Range1.949855824
Interquartile range (IQR)1.563662965

Descriptive statistics

Standard deviation0.7092579884
Coefficient of variation (CV)-264.895105
Kurtosis-1.507989269
Mean-0.002677505077
Median Absolute Deviation (MAD)0.6278742875
Skewness0.006768729133
Sum-0.7818314825
Variance0.5030468941
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.97492791 -0.8783797 0.8783797 0.97492791], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.4338837391 42 14.4%
 
0.4338837391 42 14.4%
 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
-0.4338837391 42 14.4%
 
0 41 14.0%
 
0.4338837391 42 14.4%
 
ValueCountFrequency (%) 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0.4338837391 42 14.4%
 
0 41 14.0%
 
-0.4338837391 42 14.4%
 

cos_weekday
Real number (ℝ)

Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.005559896581708024
Minimum-0.9009688679024191
Maximum1.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9009688679
5-th percentile-0.9009688679
Q1-0.9009688679
median-0.222520934
Q30.6234898019
95-th percentile1
Maximum1
Range1.900968868
Interquartile range (IQR)1.52445867

Descriptive statistics

Standard deviation0.7073551581
Coefficient of variation (CV)-127.2245172
Kurtosis-1.502452694
Mean-0.005559896582
Median Absolute Deviation (MAD)0.6399937036
Skewness0.01159750905
Sum-1.623489802
Variance0.5003513197
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.90096887 -0.90096887 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
0.6234898019 42 14.4%
 
0.6234898019 41 14.0%
 
1 41 14.0%
 
ValueCountFrequency (%) 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
0.6234898019 42 14.4%
 
ValueCountFrequency (%) 
1 41 14.0%
 
0.6234898019 41 14.0%
 
0.6234898019 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 

is_august
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
261
1
 
31
ValueCountFrequency (%) 
0 261 89.4%
 
1 31 10.6%
 

spring
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
291
1
 
1
ValueCountFrequency (%) 
0 291 99.7%
 
1 1 0.3%
 

summer
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
184
1
108
ValueCountFrequency (%) 
0 184 63.0%
 
1 108 37.0%
 

autumn
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
202
1
90
ValueCountFrequency (%) 
0 202 69.2%
 
1 90 30.8%
 

winter
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
200
1
92
ValueCountFrequency (%) 
0 200 68.5%
 
1 92 31.5%
 

roll4wd_udsventa
Real number (ℝ≥0)

ZEROS
Distinct count232
Unique (%)79.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean472.9450709393347
Minimum0.0
Maximum1293.25
Zeros50
Zeros (%)17.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1342.75
median514.4857143
Q3670.90625
95-th percentile840.88125
Maximum1293.25
Range1293.25
Interquartile range (IQR)328.15625

Descriptive statistics

Standard deviation265.7875319
Coefficient of variation (CV)0.5619839348
Kurtosis-0.3151438339
Mean472.9450709
Median Absolute Deviation (MAD)206.6661356
Skewness-0.4588403434
Sum138099.9607
Variance70643.01213
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 95.1 286.50892857 434.4375 767.70535714 980.375 1293.25 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50 17.1%
 
518.5 3 1.0%
 
700.625 2 0.7%
 
479.25 2 0.7%
 
640.375 2 0.7%
 
606 2 0.7%
 
539.5 2 0.7%
 
680.75 2 0.7%
 
719.125 2 0.7%
 
511 2 0.7%
 
Other values (222) 223 76.4%
 
ValueCountFrequency (%) 
0 50 17.1%
 
190.2 1 0.3%
 
207.4285714 1 0.3%
 
211.125 1 0.3%
 
228.25 1 0.3%
 
ValueCountFrequency (%) 
1293.25 1 0.3%
 
983.375 1 0.3%
 
977.375 1 0.3%
 
944 1 0.3%
 
936.75 1 0.3%
 

roll4wd_udsstock
Real number (ℝ≥0)

ZEROS
Distinct count246
Unique (%)84.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1091.4691903131115
Minimum0.0
Maximum2261.0
Zeros18
Zeros (%)6.2%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1850.0714286
median1103.375
Q31375.616071
95-th percentile1724.45
Maximum2261
Range2261
Interquartile range (IQR)525.5446429

Descriptive statistics

Standard deviation439.1105411
Coefficient of variation (CV)0.4023114395
Kurtosis0.8234067468
Mean1091.46919
Median Absolute Deviation (MAD)332.4997891
Skewness-0.4765377168
Sum318709.0036
Variance192818.0673
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 117. 687.57142857 1634.5 2261. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 18 6.2%
 
1524 6 2.1%
 
1240 4 1.4%
 
1040 3 1.0%
 
930 3 1.0%
 
1356 2 0.7%
 
749 2 0.7%
 
725.125 2 0.7%
 
814 2 0.7%
 
234 2 0.7%
 
Other values (236) 248 84.9%
 
ValueCountFrequency (%) 
0 18 6.2%
 
234 2 0.7%
 
395.4 1 0.3%
 
465 1 0.3%
 
474 1 0.3%
 
ValueCountFrequency (%) 
2261 1 0.3%
 
2193 1 0.3%
 
2157 1 0.3%
 
2125 1 0.3%
 
2057 1 0.3%
 

udsprevisionempresa_shifted-1
Real number (ℝ≥0)

ZEROS
Distinct count198
Unique (%)67.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2065.900684931507
Minimum0.0
Maximum17426.0
Zeros82
Zeros (%)28.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1497
Q33238
95-th percentile6362.25
Maximum17426
Range17426
Interquartile range (IQR)3238

Descriptive statistics

Standard deviation2381.258266
Coefficient of variation (CV)1.152648955
Kurtosis7.78317939
Mean2065.900685
Median Absolute Deviation (MAD)1755.857642
Skewness2.135218212
Sum603243
Variance5670390.928
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 31. 3955.5 6059.5 10036. 17426. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 82 28.1%
 
712 2 0.7%
 
289 2 0.7%
 
1700 2 0.7%
 
123 2 0.7%
 
1889 2 0.7%
 
2987 2 0.7%
 
1613 2 0.7%
 
2084 2 0.7%
 
1050 2 0.7%
 
Other values (188) 192 65.8%
 
ValueCountFrequency (%) 
0 82 28.1%
 
62 1 0.3%
 
98 1 0.3%
 
123 2 0.7%
 
169 1 0.3%
 
ValueCountFrequency (%) 
17426 1 0.3%
 
13665 1 0.3%
 
10044 1 0.3%
 
10028 1 0.3%
 
9210 1 0.3%
 

udsprevisionempresa_shifted-2
Real number (ℝ≥0)

ZEROS
Distinct count197
Unique (%)67.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2006.222602739726
Minimum0.0
Maximum13665.0
Zeros83
Zeros (%)28.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1483.5
Q33217
95-th percentile6056.45
Maximum13665
Range13665
Interquartile range (IQR)3217

Descriptive statistics

Standard deviation2206.970451
Coefficient of variation (CV)1.100062599
Kurtosis3.567751145
Mean2006.222603
Median Absolute Deviation (MAD)1700.639707
Skewness1.594447458
Sum585817
Variance4870718.572
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 31. 3955.5 7280.5 13665. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 83 28.4%
 
2078 2 0.7%
 
1700 2 0.7%
 
2322 2 0.7%
 
2987 2 0.7%
 
1050 2 0.7%
 
1613 2 0.7%
 
1889 2 0.7%
 
2084 2 0.7%
 
123 2 0.7%
 
Other values (187) 191 65.4%
 
ValueCountFrequency (%) 
0 83 28.4%
 
62 1 0.3%
 
98 1 0.3%
 
123 2 0.7%
 
169 1 0.3%
 
ValueCountFrequency (%) 
13665 1 0.3%
 
10044 1 0.3%
 
10028 1 0.3%
 
9210 1 0.3%
 
8989 1 0.3%
 

udsstock_shifted1
Real number (ℝ≥0)

Distinct count112
Unique (%)38.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1118.3391090264208
Minimum0.0
Maximum2275.0
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile510.25
Q1865
median1057.129032
Q31378.633333
95-th percentile1762.85
Maximum2275
Range2275
Interquartile range (IQR)513.6333333

Descriptive statistics

Standard deviation374.7066489
Coefficient of variation (CV)0.3350563759
Kurtosis0.6265564814
Mean1118.339109
Median Absolute Deviation (MAD)297.2696412
Skewness0.005092935235
Sum326555.0198
Variance140405.0727
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 600.5 801.22580645 807.72580645 983.96 ... 1065.5 1296.94827586 1303.44827586 1547.5 2275. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
985.92 28 9.6%
 
1432.423077 15 5.1%
 
801.4516129 13 4.5%
 
1378.633333 12 4.1%
 
1301.896552 11 3.8%
 
1055.258065 10 3.4%
 
1046 7 2.4%
 
762 6 2.1%
 
982 6 2.1%
 
1201 6 2.1%
 
Other values (102) 178 61.0%
 
ValueCountFrequency (%) 
0 1 0.3%
 
39 1 0.3%
 
64 1 0.3%
 
129 1 0.3%
 
211 1 0.3%
 
ValueCountFrequency (%) 
2275 1 0.3%
 
2261 1 0.3%
 
2157 1 0.3%
 
1989 1 0.3%
 
1951 1 0.3%
 

udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count109
Unique (%)37.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1095.6398690794479
Minimum0.0
Maximum2261.0
Zeros7
Zeros (%)2.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile424.05
Q1840
median1055.258065
Q31378.633333
95-th percentile1721.25
Maximum2261
Range2261
Interquartile range (IQR)538.6333333

Descriptive statistics

Standard deviation395.0118717
Coefficient of variation (CV)0.3605307573
Kurtosis0.7310567534
Mean1095.639869
Median Absolute Deviation (MAD)307.425108
Skewness-0.3099972447
Sum319926.8418
Variance156034.3788
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 32. 600.5 801.22580645 807.72580645 ... 1296.94827586 1303.44827586 1547.5 1970. 2261. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
985.92 27 9.2%
 
1432.423077 15 5.1%
 
801.4516129 13 4.5%
 
1378.633333 12 4.1%
 
1301.896552 11 3.8%
 
1055.258065 9 3.1%
 
0 7 2.4%
 
1046 7 2.4%
 
1201 6 2.1%
 
982 6 2.1%
 
Other values (99) 179 61.3%
 
ValueCountFrequency (%) 
0 7 2.4%
 
64 1 0.3%
 
129 1 0.3%
 
211 1 0.3%
 
232 1 0.3%
 
ValueCountFrequency (%) 
2261 1 0.3%
 
2157 1 0.3%
 
1989 1 0.3%
 
1951 1 0.3%
 
1938 2 0.7%
 

roll4wd_udsstock_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count245
Unique (%)83.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1086.6404231898239
Minimum0.0
Maximum2261.0
Zeros19
Zeros (%)6.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1848.55
median1100.125
Q31373.361607
95-th percentile1724.45
Maximum2261
Range2261
Interquartile range (IQR)524.8116071

Descriptive statistics

Standard deviation443.3281353
Coefficient of variation (CV)0.4079805295
Kurtosis0.7846908301
Mean1086.640423
Median Absolute Deviation (MAD)335.2445583
Skewness-0.4830823537
Sum317299.0036
Variance196539.8355
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 117. 687.57142857 1634.5 2261. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 19 6.5%
 
1524 6 2.1%
 
1240 4 1.4%
 
1040 3 1.0%
 
930 3 1.0%
 
1628 2 0.7%
 
749 2 0.7%
 
1057.714286 2 0.7%
 
1149.857143 2 0.7%
 
1130 2 0.7%
 
Other values (235) 247 84.6%
 
ValueCountFrequency (%) 
0 19 6.5%
 
234 2 0.7%
 
395.4 1 0.3%
 
465 1 0.3%
 
474 1 0.3%
 
ValueCountFrequency (%) 
2261 1 0.3%
 
2193 1 0.3%
 
2157 1 0.3%
 
2125 1 0.3%
 
2057 1 0.3%
 

roll4wd_udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count239
Unique (%)81.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1064.9078889432485
Minimum0.0
Maximum2261.0
Zeros25
Zeros (%)8.6%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1838.59375
median1080.5
Q31362.834821
95-th percentile1707.2125
Maximum2261
Range2261
Interquartile range (IQR)524.2410714

Descriptive statistics

Standard deviation464.2354804
Coefficient of variation (CV)0.4359395637
Kurtosis0.6121483659
Mean1064.907889
Median Absolute Deviation (MAD)349.4929172
Skewness-0.5378780552
Sum310953.1036
Variance215514.5813
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 117. 687.57142857 1634.5 2261. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 25 8.6%
 
1524 6 2.1%
 
1240 4 1.4%
 
1040 3 1.0%
 
930 3 1.0%
 
710.875 2 0.7%
 
1149.857143 2 0.7%
 
1057.714286 2 0.7%
 
1130 2 0.7%
 
725.125 2 0.7%
 
Other values (229) 241 82.5%
 
ValueCountFrequency (%) 
0 25 8.6%
 
234 2 0.7%
 
474 1 0.3%
 
558.375 1 0.3%
 
566.75 1 0.3%
 
ValueCountFrequency (%) 
2261 1 0.3%
 
2193 1 0.3%
 
2157 1 0.3%
 
2125 1 0.3%
 
2057 1 0.3%
 

udsventa_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count81
Unique (%)27.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean471.44520547945206
Minimum0.0
Maximum1938.0
Zeros57
Zeros (%)19.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1282.5
median492
Q3651.5
95-th percentile923.55
Maximum1938
Range1938
Interquartile range (IQR)369

Descriptive statistics

Standard deviation325.9941713
Coefficient of variation (CV)0.6914783893
Kurtosis1.916153376
Mean471.4452055
Median Absolute Deviation (MAD)246.4124132
Skewness0.6407138395
Sum137662
Variance106272.1997
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 68.5 231. 713. 959. 1938. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 57 19.5%
 
511 9 3.1%
 
492 7 2.4%
 
590 7 2.4%
 
600 7 2.4%
 
442 6 2.1%
 
649 6 2.1%
 
314 6 2.1%
 
354 6 2.1%
 
432 6 2.1%
 
Other values (71) 175 59.9%
 
ValueCountFrequency (%) 
0 57 19.5%
 
137 1 0.3%
 
147 1 0.3%
 
157 1 0.3%
 
216 1 0.3%
 
ValueCountFrequency (%) 
1938 1 0.3%
 
1741 1 0.3%
 
1603 2 0.7%
 
1407 1 0.3%
 
1170 1 0.3%
 

roll4_udstock_shifted1
Real number (ℝ≥0)

Distinct count269
Unique (%)92.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1109.466899714614
Minimum0.0
Maximum1782.3291666666667
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile705.6465161
Q1936.5
median1115.625
Q31290.739043
95-th percentile1505.98125
Maximum1782.329167
Range1782.329167
Interquartile range (IQR)354.2390434

Descriptive statistics

Standard deviation255.7206052
Coefficient of variation (CV)0.2304896209
Kurtosis0.7859510442
Mean1109.4669
Median Absolute Deviation (MAD)202.4618782
Skewness-0.2530785162
Sum323964.3347
Variance65393.02791
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 616.76322581 866.72708333 1320.23362661 1321.8445137 1522.47382134 1782.32916667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1192.855723 7 2.4%
 
1320.939027 6 2.1%
 
1018.674336 4 1.4%
 
1316.15885 4 1.4%
 
925.4116129 2 0.7%
 
1279.125 2 0.7%
 
991.8352957 2 0.7%
 
1175.627795 2 0.7%
 
1299.875 2 0.7%
 
1133.75 2 0.7%
 
Other values (259) 259 88.7%
 
ValueCountFrequency (%) 
0 1 0.3%
 
316.5 1 0.3%
 
539.375 1 0.3%
 
554.8291667 1 0.3%
 
568.125 1 0.3%
 
ValueCountFrequency (%) 
1782.329167 1 0.3%
 
1757 1 0.3%
 
1687.125 1 0.3%
 
1679.427885 1 0.3%
 
1677.375 1 0.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
02019-06-05301266.000000738.011310.00.00.02True0.974928-0.22252100100738.001266.017426.013665.00.0000000.0000000.00.00.00.000000
12019-06-06301378.633333944.017426.00.00.03True0.433884-0.90096900100944.000.013665.02876.01266.0000000.0000001266.00.0738.0316.500000
22019-06-07301301.896552836.013665.00.00.04True-0.433884-0.90096900100836.000.02876.00.01378.6333330.0000000.00.0944.0739.519048
32019-06-08301432.423077295.02876.00.00.05True-0.974928-0.22252100100295.000.00.05371.01301.8965520.0000000.00.0836.01154.474569
42019-06-0930985.9200000.00.00.00.06False-0.7818310.623490001000.000.05371.03684.01432.4230770.0000000.00.0295.01342.501592
52019-06-1030985.920000511.05371.00.00.00True0.0000001.00000000100511.000.03684.01661.0985.9200000.0000000.00.00.01320.939027
62019-06-1130849.000000541.03684.00.00.01True0.7818310.62349000100541.00849.01661.02900.0985.9200000.0000000.00.0511.01192.855723
72019-06-12301508.000000492.01661.00.00.02True0.974928-0.22252100100676.501326.52900.03532.0849.0000001266.000000849.01266.0541.01024.617885
82019-06-13301938.000000698.02900.00.00.03True0.433884-0.90096900100882.501938.03532.01313.01508.0000001378.6333331326.50.0492.0999.835000
92019-06-14301356.0000001033.03532.00.00.04True-0.433884-0.90096900100885.251356.01313.00.01938.0000001301.8965521938.00.0698.01249.365000

Last rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
2822020-03-13301301.8965521603.07439.00.00.04True-0.433884-0.90096900001936.7501079.00.00.01378.6333331301.8965521544.01297.000000314.0770.415941
2832020-03-14301432.4230771603.00.00.00.05True-0.974928-0.22252100001468.000234.00.0946.01301.8965521432.4230771079.0234.0000001603.01101.821343
2842020-03-1530985.9200000.00.00.00.06False-0.7818310.623490000010.0000.0946.01375.01432.423077985.920000234.00.0000001603.01316.158850
2852020-03-1630985.920000383.0946.00.00.00True0.0000001.00000000001661.1251783.01375.02265.0985.920000985.9200000.01453.5000000.01320.939027
2862020-03-173039.0000001741.01375.00.00.01True0.7818310.62349000001545.750395.42265.03526.0985.920000211.0000001783.0998.200000383.01192.855723
2872020-03-18301055.258065551.02265.00.00.02True0.974928-0.22252100001508.500465.03526.03892.039.0000001055.258065395.4725.2857141741.0923.367885
2882020-03-1930762.0000001407.03526.00.00.03True0.433884-0.90096900001621.7501153.03892.00.01055.2580651378.633333465.01544.000000551.0639.492258
2892020-03-20301511.0000001938.03892.00.00.04True-0.433884-0.900969000011293.2501295.00.00.0762.0000001301.8965521153.01079.0000001407.0628.836774
2902020-03-21302275.000000246.00.00.00.05True-0.974928-0.22252100001765.6251254.50.00.01511.0000001432.4230771295.0234.0000001938.0875.221774
2912020-03-22301410.0000000.00.00.00.06False-0.7818310.623490010010.0001410.00.00.02275.000000985.9200001254.50.000000246.01268.657258